<%@page import="tx.bjdacp.model.*" %>
<%@ page contentType="application/msexcel;charset=UTF-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib tagdir="/WEB-INF/tags/simpletable" prefix="simpletable"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn" %>
<%@ taglib uri="/struts-tags" prefix="s" %>
<%@ taglib uri="http://www.springframework.org/security/tags" prefix="sec"%>

<%@ taglib uri="http://www.rapid-framework.org.cn/rapid" prefix="rapid" %>
<%
   response.setHeader("Content-disposition","attachment; filename=data.xls");
%>



	<table width="100%"  border="1" cellspacing="0">



			  <tr>
				<th sortColumn="sample_number" ><%=SampleInfo.ALIAS_SAMPLE_NUMBER%></th>
				<th sortColumn="sample_date" ><%=SampleInfo.ALIAS_SAMPLE_DATE%></th>
				<th sortColumn="sampled_unit_name" ><%=SampleInfo.ALIAS_SAMPLED_UNIT_NAME%></th>
				<th sortColumn="unit_kind" ><%=SampleInfo.ALIAS_UNIT_KIND%></th>
				<th sortColumn="sample_unit" ><%=SampleInfo.ALIAS_SAMPLE_UNIT%></th>
				<th sortColumn="sample_product" ><%=SampleInfo.ALIAS_SAMPLE_PRODUCT%></th>
				<th sortColumn="product_type" ><%=SampleInfo.ALIAS_PRODUCT_TYPE%></th>
				<th sortColumn="amount" ><%=SampleInfo.ALIAS_AMOUNT%></th>
				<th sortColumn="batch_number" ><%=SampleInfo.ALIAS_BATCH_NUMBER%></th>
				<th sortColumn="sample_kind" ><%=SampleInfo.ALIAS_SAMPLE_KIND%></th>
				<th sortColumn="report_number" ><%=SampleInfo.ALIAS_REPORT_NUMBER%></th>
				<th sortColumn="report_date" ><%=SampleInfo.ALIAS_REPORT_DATE%></th>
				<th sortColumn="report_result" ><%=SampleInfo.ALIAS_REPORT_RESULT%></th>
				<th sortColumn="receive_report_date" ><%=SampleInfo.ALIAS_RECEIVE_REPORT_DATE%></th>
				<th sortColumn="sample_year" ><%=SampleInfo.ALIAS_SAMPLE_YEAR%></th>

			  </tr>

		  <tbody>
		  	  <c:forEach items="${page.result}" var="item" varStatus="status">

			  <tr >

				<td><c:out value='${item.sampleNumber}'/>&nbsp;</td>
				<td><c:out value='${item.sampleDateString}'/>&nbsp;</td>
				<td><c:out value='${item.sampledUnitName}'/>&nbsp;</td>
				<td><c:out value='${item.unitKind}'/>&nbsp;</td>
				<td><c:out value='${item.sampleUnit}'/>&nbsp;</td>
				<td><c:out value='${item.sampleProduct}'/>&nbsp;</td>
				<td><c:out value='${item.productType}'/>&nbsp;</td>
				<td><c:out value='${item.amount}'/>&nbsp;</td>
				<td><c:out value='${item.batchNumber}'/>&nbsp;</td>
				<td><c:out value='${item.sampleKind}'/>&nbsp;</td>
				<td><c:out value='${item.reportNumber}'/>&nbsp;</td>
				<td><c:out value='${item.reportDateString}'/>&nbsp;</td>
				<td><c:out value='${item.reportResult}'/>&nbsp;</td>
				<td><c:out value='${item.receiveReportDateString}'/>&nbsp;</td>
				<td><c:out value='${item.sampleYear}'/>&nbsp;</td>

			  </tr>

		  	  </c:forEach>
		  </tbody>
		</table>
